# DBTools DBMYSQL - MySQL Database Dump
#
# USEGO
SET FOREIGN_KEY_CHECKS=0;

# GO
# Dumping Table Structure for user

#
CREATE TABLE `user` (
  `user_id` int(10) unsigned NOT NULL auto_increment COMMENT 'user unique id',
  `username` varchar(45) NOT NULL COMMENT 'the user''s nickname',
  `password` varchar(45) NOT NULL COMMENT 'the user''s password',
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `club_id` int(10) NOT NULL,
  `function` varchar(50) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='users table';
# GO
#

# Dumping Data for user
#
BEGIN;
# GO
INSERT INTO `user` (user_id, username, password, firstname, lastname, email, club_id, function) VALUES (1, 'webmaster', '108-47554', 'Quinten', 'Verheyen', 'webmaster@schaakliga-antwerpen.info', 100, 'webmaster schaakliga Antwerpen');
# GO
INSERT INTO `user` (user_id, username, password, firstname, lastname, email, club_id, function) VALUES (2, 'voorzitter', '2900schoten', 'Guy', 'Baete', 'voorzitter@schaakliga-antwerpen.info', 100, 'voorzitter schaakliga Antwerpen');
# GO
COMMIT;
# GO
SET FOREIGN_KEY_CHECKS=1

# GO
